﻿using System;
using System.Text;
using System.Collections.Generic;
using System.Linq;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using System.Data.SqlClient;

namespace DataSetGenTest
{
    /// <summary>
    /// Summary description for UnitTest1
    /// </summary>
    [TestClass]
    public class TestDataSetCustomersOrders
    {
        public TestDataSetCustomersOrders()
        {
            //
            // TODO: Add constructor logic here
            //
        }

        private TestContext testContextInstance;

        /// <summary>
        ///Gets or sets the test context which provides
        ///information about and functionality for the current test run.
        ///</summary>
        public TestContext TestContext
        {
            get
            {
                return testContextInstance;
            }
            set
            {
                testContextInstance = value;
            }
        }

        #region Additional test attributes
        //
        // You can use the following additional attributes as you write your tests:
        //
        // Use ClassInitialize to run code before running the first test in the class
        // [ClassInitialize()]
        // public static void MyClassInitialize(TestContext testContext) { }
        //
        // Use ClassCleanup to run code after all tests in a class have run
        // [ClassCleanup()]
        // public static void MyClassCleanup() { }
        //
        // Use TestInitialize to run code before running each test 
        // [TestInitialize()]
        // public void MyTestInitialize() { }
        //
        // Use TestCleanup to run code after each test has run
        // [TestCleanup()]
        // public void MyTestCleanup() { }
        //
        #endregion

        [TestMethod]
        public void TestMethod1()
        {
            //DataSetCustomersOrders ds = new DataSetCustomersOrders();
            //using (SqlConnection cnn = ConnectionFactory.GetConnection())
            //{
            //    DataUtil.Fill(cnn, ds.Customers);
            //    DataUtil.Fill(cnn, ds.Orders);

            //    foreach (var row in ds.Customers)
            //    {
            //        row.Address = row.Address + "";
            //    }

            //    foreach (var row in ds.Orders)
            //    {
            //        row.Freight = row.Freight + 0;
            //    }

            //    //Northwind.DAL.CustomersTableAdapter adCustomers =
            //    //    new Northwind.DAL.CustomersTableAdapter();
            //    //adCustomers.UpdateCommand.UpdatedRowSource = System.Data.UpdateRowSource.FirstReturnedRecord;
            //    //adCustomers.Connection = cnn;
            //    //adCustomers.Update(ds.Customers);
            //}
        }
    }
}
